UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBKYIDUput0TpUpNggzZVO+6gZkX4Dhy2o9Z1x/hkms='
WHERE
key_id = '9e310c122eca7de28ac236f5da9479fb5d127f5f4e53a7ac46ccd19b06ffd2fd'
AND (
token = 'pBKYIDUput0TpUpNggzZVO+6gZkX4Dhy2o9Z1x/hkms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)