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