UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXykC2WbHXTMtId/i5KstqigUkO3cJI+vuhU2+uMaSc='
WHERE
key_id = '9074cd48a29e0cebb75e1f5cc0f7e0a31f844456149dbe48242f9e726683e3ae'
AND (
token = 'XXykC2WbHXTMtId/i5KstqigUkO3cJI+vuhU2+uMaSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)