UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dug4X8eb6F8AITY8fR8HZzig+a8YhctMesOU7jyqMsg='
WHERE
key_id = 'ad2746e5d47c2d7bfb73e72e048b6ae8332af871ad11d114a1de27e8f79db5f2'
AND (
token = 'Dug4X8eb6F8AITY8fR8HZzig+a8YhctMesOU7jyqMsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)