UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hexXGb5U7dIL06llxJ8VBM+jsWXkOjRVY/fqYTo6+TE='
WHERE
key_id = 'bb96f66e570f9c4d0f368a6cf2b4b00b824cd3d60ae8f5822e4caf1e73d7e216'
AND (
token = 'hexXGb5U7dIL06llxJ8VBM+jsWXkOjRVY/fqYTo6+TE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)