UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tpnsSDhZrykZkRDOhcfDmuChh8SZU2DeFoKE6a718Z4='
WHERE
key_id = 'b939f553415cda0dfc7a4268da90e017635f4b96280bb2db449cf4fef8e78771'
AND (
token = 'tpnsSDhZrykZkRDOhcfDmuChh8SZU2DeFoKE6a718Z4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)