UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nvO8Zni2TTf7wxUfuAya0FyiDEFZPa2Z7NL4TDo/TqE='
WHERE
key_id = 'f7e525ae9d73781d23d3037eb73c25a48a29b082021d9bff86fa0af43bc442ad'
AND (
token = 'nvO8Zni2TTf7wxUfuAya0FyiDEFZPa2Z7NL4TDo/TqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)