UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LDDZn+GTfe0+v86t07FVGakKpEYFlf+R2sdPU8TEpnY='
WHERE
key_id = '01e98aa31715299273f656751cf763bb43569461ca3f19d576e53d5b31a24e1a'
AND (
token = 'LDDZn+GTfe0+v86t07FVGakKpEYFlf+R2sdPU8TEpnY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)