UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YIGt2gfPnvzYd0pGtnS98gu1krMH1grcoUBaEtpWfOo='
WHERE
key_id = '1f5b091974a8ae306f94a74c3806f1900b725607c7eb66cf73e01658adba3311'
AND (
token = 'YIGt2gfPnvzYd0pGtnS98gu1krMH1grcoUBaEtpWfOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)