UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CDtPHfrEDBnFDN4Ph5i3P9oIYYc633e+pqa6iTdcCa8='
WHERE
key_id = 'bdbc043772f44c2599e4ffde70950ec81dc2175783f9d0961a26fbce7bea9ebd'
AND (
token = 'CDtPHfrEDBnFDN4Ph5i3P9oIYYc633e+pqa6iTdcCa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)