UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sT5T0H1ChjZbfz3EAfa8JcUyrCH71sXugzq4v4cUS40='
WHERE
key_id = '12ec1bd25725daa18998d24c14823316176b69bc037cbfd179d2cd8d65737f22'
AND (
token = 'sT5T0H1ChjZbfz3EAfa8JcUyrCH71sXugzq4v4cUS40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)