UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J7KMSf9zr7CGGrR4uYRvjnv4N7nmVT0f3qjuO4hNCGc='
WHERE
key_id = '02430846b5d5f0367e74cff897da0707909c766f92359d1856f0430163c4739c'
AND (
token = 'J7KMSf9zr7CGGrR4uYRvjnv4N7nmVT0f3qjuO4hNCGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)