UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9tZkJywHaV2NBtzABMSCaETdkiHDfE71FGf02uYfXfk='
WHERE
key_id = '78a6f49f3c9fa16ba76ebd095cdbbf91b34f4a218395cfbc81fa3991ddef225c'
AND (
token = '9tZkJywHaV2NBtzABMSCaETdkiHDfE71FGf02uYfXfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)