UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uXz0fcB/soZ4TH59kFqfCXzM7SyOx90/wPUCDcXI3io='
WHERE
key_id = 'c6972cf8ba5dc455705181551a672dac88b651976d4d29c04c366d0c2b21dc8d'
AND (
token = 'uXz0fcB/soZ4TH59kFqfCXzM7SyOx90/wPUCDcXI3io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)