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