UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YShiDdjoHUaqHwdWUqZK6864g6b9fcCgNYOLeFck3J8='
WHERE
key_id = '9785740d9059fabddfcd4662d60c9427a69eee495813c1317ad23a7f2fa1a507'
AND (
token = 'YShiDdjoHUaqHwdWUqZK6864g6b9fcCgNYOLeFck3J8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)