UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pubpFxEFwz5C0NwK7rfJ2Dq00u7kNM7zmLds8ngL9Fc='
WHERE
key_id = '20dedb5e03cca90bf7a769fc027b16cd2a61f4e12e130b03375878a85b4713c7'
AND (
token = 'pubpFxEFwz5C0NwK7rfJ2Dq00u7kNM7zmLds8ngL9Fc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)