UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B2hHCQqSHxZeqb7H+VBv75WxQRBsuTznpMKuU+rcTFI='
WHERE
key_id = 'dcf3c87313e4ce5f3a2423f040372e7a4cf0b4effcce6a208a2392b4310187f1'
AND (
token = 'B2hHCQqSHxZeqb7H+VBv75WxQRBsuTznpMKuU+rcTFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)