UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dAkHJOfQ4SRmKxz8PsXTCLX2vX3svOnkhIJbgaRwJf0='
WHERE
key_id = '6c4e3e2b49873094f9bccb8c191ca055d790f40c34221399632bf34a1e585cb2'
AND (
token = 'dAkHJOfQ4SRmKxz8PsXTCLX2vX3svOnkhIJbgaRwJf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)