UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thGWlMPtC9YWyJUdumry7sx9K+Epb0v++Vs+JS8kXwI='
WHERE
key_id = 'd358bd130857f5ff349a081ad4c0214f3a697a0b11ad9b8befde59e5cdbf0de8'
AND (
token = 'thGWlMPtC9YWyJUdumry7sx9K+Epb0v++Vs+JS8kXwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)