UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8fQ+u8wEnrF1BI1F+7gaGKzSCPFLypTRGoPxQyMSpgk='
WHERE
key_id = '27eed79330408a37a414f72aac84f1a68adc0aeb30099b5e2dafe8fcc7d9dde4'
AND (
token = '8fQ+u8wEnrF1BI1F+7gaGKzSCPFLypTRGoPxQyMSpgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)