UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zD6onnR5C+tCLyLB0RsSelyB1VrBDZi15ujcnmVr6EU='
WHERE
key_id = '39a25b33992d8f46f7adc06422d022366e89f8029b7133751c613f5d6967cea6'
AND (
token = 'zD6onnR5C+tCLyLB0RsSelyB1VrBDZi15ujcnmVr6EU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)