UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tfl8IKQPrYkj0Ec4asgxa8zORLbUwogCUSEVqZ+RVLU='
WHERE
key_id = 'd6e27d0728de3822bd3fac009a80b4a587084808312ee0b50b93f2ec7d9513b9'
AND (
token = 'tfl8IKQPrYkj0Ec4asgxa8zORLbUwogCUSEVqZ+RVLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)