UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+8kSX/KWH+IylUvf82+kZr+OHhueouFqgN5BDn7P8hc='
WHERE
key_id = '512053f553fddfb40c9e75474a286ebfd97dc547518b05b38303e427977bc950'
AND (
token = '+8kSX/KWH+IylUvf82+kZr+OHhueouFqgN5BDn7P8hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)