UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8+cvzcnpK2bY3QDdsLX5bwrjRvxZzUr24keUbxaGis='
WHERE
key_id = '38de59c152aff2579bfb9317bba726e7afb522f289f85f348b04d5ab8cbd9b86'
AND (
token = 'J8+cvzcnpK2bY3QDdsLX5bwrjRvxZzUr24keUbxaGis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)