UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cGxIdiuwCN7Iu8usLeb1wA6n7UTK+t9Gajfy+Wdx3Bs='
WHERE
key_id = 'c155760127b2b0958b9c1d769ddf8addf9468bf8878c8dbfa8fb217abc597316'
AND (
token = 'cGxIdiuwCN7Iu8usLeb1wA6n7UTK+t9Gajfy+Wdx3Bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)