UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jGI4d9F+h5biSy+f9LVDLLRzFYiJjWd26DPPqNX5wSo='
WHERE
key_id = '5167374dde18638db11e904a2e5fc192dd3542a3c4484fcd97df3947f7169b16'
AND (
token = 'jGI4d9F+h5biSy+f9LVDLLRzFYiJjWd26DPPqNX5wSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)