UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cD2g/de6utfhb8Kkt1WLX580xkhDEO/kzNYr/R0XQtE='
WHERE
key_id = '1f6c2f759d6805843c4b0e770b46910a0e7d8e38c1562c7b00c58642de261243'
AND (
token = 'cD2g/de6utfhb8Kkt1WLX580xkhDEO/kzNYr/R0XQtE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)