UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JXopyvLqePcJAi+qIddyC7WzdrMYnAVNqlY95IOfxEc='
WHERE
key_id = 'b4ff1e5a228a681accec70b4dac01cb6ebb674cc8682367fde0a6de6a5db384b'
AND (
token = 'JXopyvLqePcJAi+qIddyC7WzdrMYnAVNqlY95IOfxEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)