UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kPwCsi8zh89LSTb+ay+tD/bsIWrOi/A/xJUKrvspD7c='
WHERE
key_id = 'a2b3ca12ea9845d74cab78e42ea8f9f7a23bea9b5d0aa97f2b2c319723a7af7c'
AND (
token = 'kPwCsi8zh89LSTb+ay+tD/bsIWrOi/A/xJUKrvspD7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)