UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rnow/xaJW8q2M+ePVWbr24b8nf68xT+EW9lXU6Ne7jI='
WHERE
key_id = 'a8af1e15ae2a2db89732bf7c84203a3f89901b675335b2f510323163789199c8'
AND (
token = 'rnow/xaJW8q2M+ePVWbr24b8nf68xT+EW9lXU6Ne7jI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)