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