UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0EN0zV2UB5Ex19gq1D1jzdigY719xa3ZC5DBmyj2ccM='
WHERE
key_id = '9280d2e38b836f3acaa2df9b04b764537c2017a1afd06520003ce1f9f90ec017'
AND (
token = '0EN0zV2UB5Ex19gq1D1jzdigY719xa3ZC5DBmyj2ccM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)