UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mjBy9qjcycAOipwlHFlFYtjqO1w9WgGcy1fgL9s0HOI='
WHERE
key_id = 'ac5dd79bb98dbd1d2741d512f4ff6c6ca646733c2ac4f2158e9950a96d69a9f4'
AND (
token = 'mjBy9qjcycAOipwlHFlFYtjqO1w9WgGcy1fgL9s0HOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)