UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iSbd5eFAuCZvrLRmsCB2jk+IiuPNq5MXBhHhI79dYKM='
WHERE
key_id = '5501ceb06b0935bc93730b744361301234ea2c2a97d2174fd6986562543134eb'
AND (
token = 'iSbd5eFAuCZvrLRmsCB2jk+IiuPNq5MXBhHhI79dYKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)