UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hclAj7pGWYWFXg/YNaobWmpI+EM8iKdrKrwo6kSq7GU='
WHERE
key_id = '87c692bbc885a8334e15b015adc6e8686711834ac8c653dc25827e9deb98a774'
AND (
token = 'hclAj7pGWYWFXg/YNaobWmpI+EM8iKdrKrwo6kSq7GU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)