UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YGjp1UCyoaa+4lYnlgi1zlrV4fAV/aPF7Cajfc49TLk='
WHERE
key_id = '842a96c6d8dd70d409429cebeba75b4c653c0314f748a11adc84d064492922a0'
AND (
token = 'YGjp1UCyoaa+4lYnlgi1zlrV4fAV/aPF7Cajfc49TLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)