UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nkBYtFVd4ID+mQzkw77s933ejRc1mf1cyDVdR76Zk3A='
WHERE
key_id = '28c231518451eb818bf3bd6f54f572eb36f782c60491bb68980c7e5b9f55668c'
AND (
token = 'nkBYtFVd4ID+mQzkw77s933ejRc1mf1cyDVdR76Zk3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)