UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0CkpiibwP1fmOM/UhopN+Yn+mJrV5QISMUZyaBAFffw='
WHERE
key_id = '4fa9c03ec912bebd8d8bda84d72eda566d3ee80e0de6bb615b101130723342fc'
AND (
token = '0CkpiibwP1fmOM/UhopN+Yn+mJrV5QISMUZyaBAFffw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)