UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v1b2HG76XpebD5lEY0MnLLWvC17lCc51Vz5kjlHNVUo='
WHERE
key_id = '94484a6f154972e66416e38840ad009e851063fb53783fa2d1ba145e12b98b4e'
AND (
token = 'v1b2HG76XpebD5lEY0MnLLWvC17lCc51Vz5kjlHNVUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)